// $Id$
package at.etel.jdbc;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import oracle.jdbc.pool.OracleDataSource;
import org.apache.log4j.Logger;

public class OracleTest
{
  private static Logger log 
      = Logger.getLogger(Thread.currentThread().getStackTrace()[0].getClassName());
  public static void main(String argv[]) {
    String connectString 
//        = "dbc:oracle:thin:@192.168.193.30:1521:EUDB";
      = "dbc:oracle:thin:@192.168.63.112:1521:EUDB";
    String username = "euidb";
    String password = "test";
    try {
      OracleDataSource oracleDataSource = new OracleDataSource();
      oracleDataSource.setURL(connectString);
      Connection connection 
          = oracleDataSource.getConnection(username, password);
      DatabaseMetaData metadata = connection.getMetaData();
      ResultSet resultSet 
          = metadata.getProcedureColumns(null, null, "WEB_PASSWD_CHG_OCCURRED", null);
      while (resultSet.next()) {
        log.info(resultSet.getString(1) + "\n");
      }
    } catch (Throwable t) {
      t.printStackTrace();
    };
  }
}


